| year | week | total_post | claim_id | search_volume | weight_per_unit | sales_dollars_value | |
|---|---|---|---|---|---|---|---|
| 0 | 2018.000000 | 48.000000 | 626.000000 | 75.000000 | 10737.000000 | 0.360000 | 53929 |
| 1 | 2017.000000 | 51.000000 | 915.000000 | 158.000000 | 74850.000000 | 5.620000 | 207827 |
| 2 | 2017.000000 | 49.000000 | 729.000000 | 187.000000 | 28773.000000 | 12.020000 | 2224116 |
| 3 | 2018.000000 | 40.000000 | 125.000000 | 152.000000 | 11640.000000 | 0.130000 | 20806 |
| 4 | 2019.000000 | 25.000000 | 22.000000 | 430.000000 | 9788.000000 | 2.460000 | 5724950 |
| year | week | total_post | claim_id | search_volume | weight_per_unit | sales_dollars_value | |
|---|---|---|---|---|---|---|---|
| 2079 | 2017.000000 | 13.000000 | 307.000000 | 151.000000 | 31698.000000 | 10.680000 | 359022 |
| 2080 | 2016.000000 | 8.000000 | 63.000000 | 152.000000 | 14138.000000 | 0.130000 | 18163 |
| 2081 | 2016.000000 | 12.000000 | 151.000000 | 151.000000 | 12675.000000 | 11.250000 | 259271 |
| 2082 | 2019.000000 | 4.000000 | 313.000000 | 187.000000 | 27776.000000 | 13.100000 | 2497804 |
| 2083 | 2017.000000 | 18.000000 | 1746.000000 | 438.000000 | 80106.000000 | 17.200000 | 3026117 |
No missing values in data
No Infinity values
No Missing Values
No duplicate variables
| N | < (mean-3*std) | > (mean+3*std) | < (1stQ - 1.5 * IQR) | > (3rdQ + 1.5 * IQR) | -inf | +inf | |
|---|---|---|---|---|---|---|---|
| Feature | |||||||
| total_post | 2084 | 0 | 56 | 0 | 276 | 0 | 0 |
| search_volume | 2084 | 0 | 32 | 0 | 84 | 0 | 0 |
| weight_per_unit | 2084 | 0 | 0 | 0 | 102 | 0 | 0 |
| sales_dollars_value | 2084 | 0 | 8 | 0 | 206 | 0 | 0 |
| Variable Name | Datatype | No of Unique | Samples | Mean | Standard Deviation | Min | 25th percentile | Median | 75th percentile | Max | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | claim_id | float64 | 19 | [75.0, 158.0, 187.0, 152.0, 430.0] | 184.548944 | 129.848004 | 8.000000 | 81.000000 | 158.000000 | 227.000000 | 438.000000 |
| 1 | sales_dollars_value | int64 | 2006 | [53929, 207827, 2224116, 20806, 5724950] | 2566164.447217 | 3821680.446707 | 98.000000 | 55669.750000 | 291738.500000 | 3343831.500000 | 16009176.000000 |
| 2 | search_volume | float64 | 1897 | [10737.0, 74850.0, 28773.0, 11640.0, 9788.0] | 25188.076489 | 28745.937901 | 3.000000 | 4159.000000 | 11961.000000 | 39725.750000 | 113693.856316 |
| 3 | total_post | float64 | 972 | [626.0, 915.0, 729.0, 125.0, 22.0] | 655.345847 | 867.585682 | 0.000000 | 86.750000 | 296.000000 | 761.000000 | 3578.049019 |
| 4 | week | float64 | 52 | [48.0, 51.0, 49.0, 40.0, 25.0] | 25.123800 | 14.476794 | 1.000000 | 13.000000 | 25.000000 | 37.000000 | 52.000000 |
| 5 | weight_per_unit | float64 | 887 | [0.36, 5.62, 12.02, 0.13, 2.46] | 5.292740 | 5.139163 | 0.130000 | 1.347500 | 3.395000 | 7.662500 | 18.530000 |
| 6 | year | float64 | 4 | [2018.0, 2017.0, 2019.0, 2016.0] | 2017.501440 | 1.102303 | 2016.000000 | 2017.000000 | 2018.000000 | 2018.000000 | 2019.000000 |
No categorical columns
No categorical variables in data.
| Variable 1 | Variable 2 | Corr Coef | Abs Corr Coef | |
|---|---|---|---|---|
| 0 | sales_dollars_value | total_post | 0.479140 | 0.479140 |
| 1 | total_post | sales_dollars_value | 0.479140 | 0.479140 |
| 2 | sales_dollars_value | search_volume | 0.154018 | 0.154018 |
| 3 | search_volume | sales_dollars_value | 0.154018 | 0.154018 |
| 4 | claim_id | sales_dollars_value | 0.036433 | 0.036433 |
| 5 | sales_dollars_value | claim_id | 0.036433 | 0.036433 |
| 6 | sales_dollars_value | weight_per_unit | 0.029835 | 0.029835 |
| 7 | weight_per_unit | sales_dollars_value | 0.029835 | 0.029835 |
| 8 | sales_dollars_value | year | 0.005065 | 0.005065 |
| 9 | year | sales_dollars_value | 0.005065 | 0.005065 |
| 10 | sales_dollars_value | week | -0.001520 | 0.001520 |
| 11 | week | sales_dollars_value | -0.001520 | 0.001520 |